v 2.2 (24 February 2003)
Release
Database Comparer helps to compare,
synchronize and update databases structure. You can compare
one database with another database or database with SQL/DDL
script or even two SQL/DDL scripts!
Database Comparer implements highly
intelligent and robust synchronization algorithm. During first
comparison step it takes Target database or Target SQL/DDL
script and compare it to the Master database or Master SQL/DDL
script trying to locate all structure differences and prepare
final SQL script which will be applied to the Target and make
its structure equal to Master structure.
At this stage Database Comparer
extracts all objects, descriptions and links from both Master
and Target structures and then compares actual objects from
Master with objects from Target building final update SQL
script. After final update SQL script is ready you can apply
it to the Target database if it is available or just save it
to the file and run it later.
Database Comparer also support batch
mode so you can synchronize list of Target databases with
given Master database or SQL/DDL script at one pass.
Database Comparer main
features:
- Can compare database with database, database with
SQL/DDL script and SQL/DDL script with SQL/DDL script.
- You can optionally select which objects (domains,
tables, procedures, triggers etc.) should be compared.
- Intelligent comparison with automatic results control
after each phase provides excellent results even if Master
and Target structures are very different and / or have many
linked objects.
- Original and proven algorithms to synchronize and update
linked objects.
- Batch mode for most operations.
- Build-in additional functionality such as:
- database
cloning - data synchronization within selected
tables - drop all constraints or only constraints with
specified type - database backup/restore with batch mode
support - database validation
- Ability to browse Master and Target structure trees and
visually display the differences between them.
- Final update SQL script can be edited or broken onto
separate steps using built-in SQL editor with highlight
feature. You can manually change steps order or optionally
disable selected steps.
- Detailed context help system included.
- Native, highly function and powerful user interface.
If you are database administrator,
developer or just need to support bunch of databases this tool
is designed for you! It will not only save your time and money
but also makes sure that you are not missing anything and will
not get into serious problems which might be caused by
database structure differences.
Database Comparer currently supports
InterBase, FireBird and Yaffil servers only.
Please take a tour and check Database
Comparer screenshots
Important!
Database Comparer is free for
non-commercial use.Please feel free to use it for educational
purposes and you are always welcome to order commercial
license from Database Comparer Order page. |